Save
Ask
Tour
Hide
Share
$1,239,000
New Listing

797 Western Road
Castleton, NY 12033

For Sale|Single Family Residence|Active
6
Beds
3
Total Baths
3
Full Baths
3,647
SqFt
$340
/SqFt
1829
Built
County:
Rensselaer
Listing courtesy of Aubrey D Guri of Howard Hanna Capital Inc
Call Now: 518.963.8181
Is this the listing for you? We can help make it yours.
518.963.8181
797 Western Road797 Western Road797 Western Road797 Western Road
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

$5,653
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2026 Information is deemed reliable but not guaranteed.

A remarkable hilltop colonial manor home overlooking magnificent Hudson Valley views, where sunsets melt gently into the horizon, and the sky feels endlessly expansive. Established in 1829, Enderley Farm has been thoughtfully and lovingly restored to impeccable, move-in condition, and was featured on HGTV. This six-bedroom, three-full-bath residence honors its historic roots while embracing modern comfort. Preserved craftsmanship tells the story of its past, while every major system, plumbing, electrical, heating, foundation, and roof, has been fully upgraded to ensure peace of mind for years to come. Let this lifestyle unfold while pursuing your dreams and passions in an idealistic and serene setting. This 64-acre spread of land offers the best of mountain views, peaceful seclusion, and has perfect southern exposures for growing. Trails weave through the acreage, perfect for riding, walking, or winter sports. Walking the fields and forested trails, the majesty of this historic property comes to life as you feel like you are in your own state park. The open fields are perfectly suited for small-scale farming or for horses or other animals that can graze under the endless skies. The barn is complete with three stalls, a hay loft with drops, a separate office, and a large interior space with a new stamped concrete floor, perfect for equestrian pursuits, hobbies, or social gatherings. A pool framed by grapevines and a charming cabana creates a peaceful retreat for gathering with friends or unwinding beneath the open sky. Each season unveils its own quiet, picturesque beauty.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$1,239,000
Days On Site 
0 Days
Bedrooms 
6
Inside Area (SqFt) 
3,647 sqft
Total Baths 
3
Full Baths 
3
Partial Baths 
N/A
Lot Size 
64.57 Acres
Year Built 
1829
MLS® Number 
202612988
Status 
Active
Property Tax 
$16,583
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
N/A
Friends & Family
Recent Activity
9 hours agoListing first seen on site
9 hours agoListing updated with changes from the MLS®
General Features
Acres 
64.57
Attached Garage 
Yes
Foundation 
CombinationStone
Garage 
Yes
Garage Spaces 
2
Green Energy Efficient 
Appliances
Parking 
Off StreetStorageWorkshop in GarageAttachedCircular DrivewayDrivewayGarage Door OpenerHeated GarageGarage
Parking Spaces 
10
Property Condition 
Updated/Remodeled
Property Sub Type 
Single Family Residence
Security 
Smoke Detector(s)Carbon Monoxide Detector(s)
Sewer 
Septic Tank
Special Circumstances 
Standard
SqFt Above 
3647
Style 
ColonialFarmFarmhouse
Utilities 
Cable Connected
Water Source 
Cistern
Interior Features
Appliances 
Ice MakerDishwasherDryerENERGY STAR Qualified AppliancesMicrowaveOvenRangeRange HoodRefrigeratorWasherWine Cooler
Basement 
Interior EntrySump PumpUnfinished
Cooling 
Window Unit(s)
Electric 
200+ Amp ServiceCircuit Breakers
Fireplace Features 
Wood Burning StoveBedroomFamily Room
Flooring 
TileWoodCeramic TileHardwood
Heating 
OtherRadiantSteamWood Stove
Interior 
High Speed InternetWet BarBuilt-in FeaturesCrown MoldingEat-in KitchenKitchen Island
Laundry Features 
Laundry RoomMain Level
Window Features 
ScreensShuttersStorm Window(s)Window CoveringsWindow TreatmentsWood FramesBlindsENERGY STAR Qualified WindowsInsulated Windows
Bedroom 
Level - SecondDescription - Window seat
Dining Room 
Level - FirstDescription - Formal Dining Rm
Family Room 
Level - FirstDescription - Wood Stove
Full Bathroom 
Level - SecondDescription - Clawfoot tub
Game Room 
Level - FirstDescription - Billiards Rm w/ Wet Bar
Kitchen 
Level - First
Laundry 
Level - First
Office 
Level - FirstDescription - Access to screened porch
Other 
Level - FirstDescription - Breakfast Room
Primary Bedroom 
Level - SecondDescription - With sitting area & wood stove. 2nd story porch
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
StoneWood Siding
Exterior 
GardenLighting
Fencing 
ElectricFencedGate
Lot Features 
SecludedLevelMeadowPrivateViewsWoodedBluffClearedGardenLandscaped
Other Structures 
Barn(s)Other
Patio And Porch 
ScreenedSide PorchCoveredEnclosedFront PorchPatioPorch
Pool Features 
In Ground
Roof 
ShingleAsphalt
View 
MeadowMountain(s)OrchardPastureSkylineTrees/WoodsValleyHills
Waterfront Features 
Stream
Waterview 
MeadowMountain(s)OrchardPastureSkylineTrees/WoodsValleyHills
Windows/Doors 
ScreensShuttersStorm Window(s)Window CoveringsWindow TreatmentsWood FramesBlindsENERGY STAR Qualified WindowsInsulated Windows
Community Features
School District 
Schodack
Schools
School District
Schodack
Elementary School
Unknown
Middle School
Unknown
High School
Maple Hill HS
Listing courtesy of Aubrey D Guri of Howard Hanna Capital Inc



Listing information is provided by Participants of the Global MLS. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. Copyright 2026, Global MLS.
Last checked: 2026-03-09 10:54 PM UTC

Neighborhood & Commute
Source: Walkscore
Save
Ask
Tour
Hide
Share